CREATE VIEW ArtistWorkNet AS
SELECT 		W.WorkID, ArtistName, Title, Copy, AcquisitionPrice,
			SalesPrice, (SalesPrice - AcquisitionPrice) AS NetPrice
FROM 		TRANS T
JOIN		WORK W
			ON T.WorkID = W.WorkID
			JOIN ARTIST A
				ON W.ArtistID = A.ArtistID;
go			
				
CREATE VIEW 	WorkNet AS
SELECT			ArtistName, Title, Copy, sum(NetPrice) AS TotalNet
FROM			ArtistWorkNet
GROUP BY		ArtistName, Title, Copy;

go

CREATE VIEW		ArtistNet AS
SELECT			ArtistName, sum(NetPrice) AS TotalNet
FROM 			ArtistWorkNet
GROUP BY		ArtistName;